The objective of the DataViz Makeover is to reveal inter- and intra-zonal public bus flows at the planning sub-zone level of January 2022.
The aim of the task is to reveal inter- and intra-zonal public bus flows at the planning sub-zone level of January 2022.
There are 5 parts to the task:
Critique the clarity and aesthetics of the original graph, providing at least three observations from each evaluation criterion.
With reference to the critique above, suggest an alternative graphical presentation to improve the current design, providing descriptions of the advantages or solutions provided by the alternative.
Design the proposed data visualisation with Tableau.
Provide step-by-step descriptions of how the data visualisation was prepared.
Describe three major observations revealed by the data visualisation prepared.
The original visualisation can be found “here” on Tableau Public.
Overall, the visualisation is assessed to be “Confusing and Ugly” (Sorry, Prof!).
Missing Dimension: The dataset contained origin-destination (OD) information regarding the bus trips, as well as data on the locations of these bus stops by Planning region, area and subzone. All this geographical information was not represented in the current visualisation.
Adjacency Matrix:The adjacency matrix on the right hand side has too many levels, making the matrix difficult to interpret since the different colours across the grid can hardly be distinguished from one another.
Missing Data: The dataset contained information regarding bus trips that occurred between 0,1 and 4 hours but this information was not included in the visualisation. Interesting observations on day/night flow of buses might be missed because of this.
Title: The chart has no overall title to explain the what (“Bus Trips”), the what (“Origin-Destination” flows), the where (“Singapore”) and the when (“January 2022”) of the data. There is also no explanation that “Sz” refers to planning Subzones.
Too many charts: There were too many charts in a single view, making it difficult for the viewers’ eyes to focus on the most pertinent information revealed by the visualisations.
Repetitive axes: The y-axis had repeated labels for “WEEKDAY” and “WEEKEND”. This took up unnecessary space on the page and could be streamlined to just a single set of labels on the left.
Legend: Instead of a radio-button list, the legend could have been formatted as a multi-selection drop down menu for a cleaner and more organised look.
Colour: The visualisation did not make effective use of the colour dimension to highlight interesting variations in the data e.g. differences in the relative number of trips generated to and from the subzones.
The first priority in DataViz Makeoever is to retain the original design as much as possible, and improve on the current design. To that end, the proposed design considers the following:
Based on the current design, the purpose of the visualisation seems to be to compare weekday vs. weekend, inter- and intra-zonal bus trips in Singapore
To that end, a chloropleth map of Singapore will be used in place of the bar charts. Although this replaces the original choice of chart type, and should not usually be encouraged, it is crucial for this particular dataset that we use a map to show the geographical dimension of the data.
The adjacency matrices will be retained but to improve interpretability, instead of using subzones, which has 303 levels, we will use the 55 planning areas to segment each element on the grid. This will give us a clearer visual while preserving the purpose of the matrix, which is to visualise inter/intra zonal flows.
A sketch of the proposed alternative visualisation design is shown below:
The proposed alternative visualisation tries to make the following improvements:
Tooltips: The new design provides interactive information on the subzone destination and number of trips to this subzone from the origin.
Use of colours: Unlike the original, the alternative design uses the colour spectrum via the chloropleth and adjacency matrix to reveal relative differences in the trips made to and from different locations at different times of the day.
Titles: Simple and clear chart titles supported by explanatory notes on how to navigate the visualisation. The Title will change dynamically depending on choice of filters.
Layout: Used Storyboard to tabs within the page layout where the map views, and adjacency matrices are put in separate tabs within the same page so that we can view a larger grid, yet still give viewers the sense that it’s still the same visualisation.
Legend*: Tidied up the legend by using multi-select drop down menu format. Included a time slider to allow user to filter by time period of interest.
The Dashboards can be viewed on Tableau Public here
A selection of programmes including Tableau Prep, JMP Pro and Excel was used to clean and pre-process the data. Tableau Desktop was used for the visualisations. To reproduce this visualisation makeover, detailed steps can be found at the “Data Prep Log” section.
Generally, it was revealed from the map that bus riders living in different zones have different locus of travel.
Travel during this period would usually be by workers travelling to their workplaces. By observing the different origin locations during this time period, we can see that workers living in some areas tend to have work places closer to their homes:
The travel patterns for weekend nights revealed differences between central areas and residential areas. For e.g. Trips departing from Orchard, a shopping district, travelled widely to all parts of the island. However, the volume of rides is relatively low (>100 trips max).
In contrast, trips departing from Tampines are high in number (>2,000 trips max) but extending only to within the zone. These are likely residents who are returning home from weekend social activities and catching the feeder buses back from from the train stations.
For example, from the differences in colour intensity, it can be seen that the majority (14.8%) of the buses that depart Choa Chu Kang, terminate in Choa Chu Kang, viz Marine Parade that has trips spread out across most areas even though the total volume of trips is less that Choa Chu Kang.
Places like Boon Lay and Marina South show that the buses ply only specific locations nearby (Boon Lay-Jurong East/West, Marina South-Straits View), as can be seen by the deeper coloured boxes at those locations while most of the row is blank. The buses here could be to serve as feeders or shuttle services.
The reasons for these differences are several. It might be because of the availability of cross-island buses that are more common in older/central towns like Bukit Merah, or the preferences of riders (e.g. some may prefer taking the train). It could also be planning policies that site work places closer to residential areas so people do not need to travel out too far and cause congestion during peak periods or efforts to shift trans-island travelling to the MRT trains rather than buses, limiting bus travel more to serve intra-zonal travellers covering shorter distances.